<?php
/** 
 * Lookup_model
 * This class handles model work necessary for logging in user
 * 
 * @author Ray Nowell
 *	
 */ 
class Lookup_model extends CI_Model {

	function Lookup_model()
	{
		parent::__construct();
	}
	
	/*
	 * 
	 */
	function Load_lookup_info($lookup_category)
	{
    
    $select_fields = " lookup_id
                      ,`short_name`
                      ";
										 
		//Get the query results 
		$this->db->select($select_fields,false);
		$this->db->from('lookup');
    $this->db->join('lookup_category', 'lookup.category_id = lookup_category.category_id');
		$this->db->where('category',$lookup_category);
		$this->db->order_by('`short_name`');
		$query = $this->db->get();
				
		return $query->result_array();
	}


	
}

/* End of file Lookup_model.php */
/* Location: ./system/application/models/Lookup_model.php */